package com.dingding.activity.core.activity.dao.sql;

/**
 * 
 * @Description: 优惠券SQL相关操作类
 * @author CHEHUANBO
 * @date 2016年12月9日
 * @version V2.6.2
 * 
 */
public class CouponSQL {

	/**
	 * 
	 * 通过活动ID获取关联的优惠券
	 * 
	 * @author CHEHUANBO
	 * 
	 */
	public static final String GET_COUPON_BY_ACTIVITYID = "SELECT cp.couponId,cp.couponName,cp.couponTypeId,cp.faceValue,cp.startTime,cp.endTime,cp.useScope,cp.cityScope,cp.number,cp.enoughMoney,cp.maximum,cp.couponDiscounts,cp.createTime,cp.couponStatus FROM dd_coupon cp INNER JOIN dd_activity_coupon dac ON dac.couponId = cp.couponId WHERE dac.activityId = ?";

}
